package cn.sicnu.cs.employment.mapper;

import cn.sicnu.cs.employment.domain.entity.EmployeeExpEducation;
import cn.sicnu.cs.employment.domain.entity.EmployeeExpInternship;
import cn.sicnu.cs.employment.domain.entity.EmployeeExpProject;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.sql.CallableStatement;
import java.util.Date;
import java.util.List;
import java.util.Set;

@Mapper
public interface EmployeeExpMapper extends BaseMapper<EmployeeExpProject> {

    Set<EmployeeExpEducation> selectEducationExp(@Param("id")Long id);

    Set<EmployeeExpProject> selectProjectExp(@Param("id")Long id);
    Set<EmployeeExpProject> selectProjectExp(@Param("id")Long id, @Param("isAppeal")String isAppeal);

    Set<EmployeeExpInternship> selectInternshipExp(@Param("id")Long id);

    Set<EmployeeExpProject> selectProjectExpByComAndEmp(@Param("empId") Long id, @Param("comId") Long comId, @Param("isAppeal")String isAppeal);
    Set<EmployeeExpProject> selectProjectExpByComAndEmp(@Param("empId") Long id, @Param("comId") Long comId);

    Date getCreateTime(@Param("id") Long id);
    Date getCreateTime(@Param("id") Long id, @Param("isAppeal")String isAppeal);
}
